Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_7056

R_7056

ActionType

DiagnosesHistory

ActionTypeID

 

 

R_9044

R_9044

DictionaryValue

NursingCareCategory

CategoryID

 

 

R_9045

R_9045

Episode

NursingCareCategory

EpisodeID

 

 

R_9046

R_9046

Person

NursingCareCategory

DescribingPersonID

 

 

R_9740

R_9740

ICD

DiagnosisListItem

ICDID

 

 

R_9741

R_9741

Patient

DiagnosisListItem

PatientID

 

 

R_9742

R_9742

DiagnosisListItem

DiagnosisListItemStatus

DiagnosisListItemID

 

 

R_9743

R_9743

Event

DiagnosisListItemStatus

EventID

 

 

R_9744

R_9744

DiagnosisCharacter

DiagnosisCharacterText

DiagnosisCharacterID

 

 

R_9745

R_9745

DiagnosisInjury

DiagnosisInjuryText

DiagnosisInjuryID

 

 

R_9746

R_9746

DiagnosisInjury

LEventICD

DiagnosisInjuryID

 

 

R_9747

R_9747

DiagnosisCharacter

LEventICD

DiagnosisCharacterID

 

 

R_10014

R_10014

Employer

SickLeave

EmployerId

 

 

R_10015

R_10015

Address

SickLeave

EmployerAddressId

 

 

R_10016

R_10016

Person

SickLeave

InsuredId

 

 

R_10017

R_10017

Address

SickLeave

InsuredAddressId

 

 

R_10019

R_10019

Address

SickLeave

OrgUnitAddressId

 

 

R_10020

R_10020

SickLeave

SickLeaveZusDoc

SickLeaveId

 

 

R_10021

R_10021

Personnel

SickLeaveZusDoc

Per_PersonID

 

 

R_10339

R_10339

SickLeave

SickLeaveZusNo

SickLeaveID

 

 

R_10419

R_10419

FormInstance

NursingCareCategory

FormInstanceID

 

 


1  2